import java.io.*;

import java.net.*;

import java.sql.*;

public class Target extends Thread { //implements Runnable {

   Socket socket;

   DataOutputStream out=null;

   DataInputStream  in=null;

   PreparedStatement sqlOne,sqlTwo;

   boolean boo=false;

   Target(Socket t, PreparedStatement sqlOne,PreparedStatement sqlTwo) {

      socket=t;

      this.sqlOne=sqlOne;

      this.sqlTwo=sqlTwo;  

      try {  out=new DataOutputStream(socket.getOutputStream());

             in=new DataInputStream(socket.getInputStream());

      }

      catch(IOException e){

          System.out.println(e);

      }

   }  

   public void run() {

      ResultSet rs = null; 

      while(true) {

        try{

            String str=in.readUTF();

            if(str.startsWith("number:")) {

               str = str.substring(str.indexOf(":")+1);

               sqlOne.setString(1,str);

               rs=sqlOne.executeQuery();

            }

            else if(str.startsWith("name")) {

               str = str.substring(str.indexOf(":")+1);

               sqlTwo.setString(1,str);

               rs=sqlTwo.executeQuery();

            }

            while(rs.next()) {

               boo=true;

               String number=rs.getString(1);

               String name=rs.getString(2);

               Date time=rs.getDate(3);

               float height=rs.getFloat(4);

               out.writeUTF("学号:"+number+"姓名:"+name+"出生日期:"+ time+ 

	               "身高:"+height); 

            }

            if(boo==false)

               out.writeUTF("没该学号！");

       }

       catch (IOException e) { 

           System.out.println("客户离开"+e);

               return;

       }

       catch (SQLException e) { 

           System.out.println(e);

       }

     }

   } 

}
